Download Oracle Database 12c SQL Fundamentals.1z0-061.BrainDumps.2018-10-27.206q.vcex

Vendor:	Oracle
Exam Code:	1z0-061
Exam Name:	Oracle Database 12c SQL Fundamentals
Date:	Oct 27, 2018
File Size:	11 MB
Downloads:	4

Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAMFILESCOM

Discount: 20%

Demo Questions

You need to produce a report where each customer's credit limit has been incremented by $1000. In the output, the customer's last name should have the heading Name and the incremented credit limit should be labeled New credit Limit. The column headings should have only the first letter of each word in uppercase.

Which statement would accomplish this requirement?

Option A
Option B
Option C
Option D

Correct answer: C

Explanation:

A column alias:Renames a column heading Is useful with calculations Immediately follows the column name (There can also be the optional AS keyword between the column name and the alias.) Requires double quotation marks if it contains spaces or special characters, or if it is case sensitive.

View the Exhibit and examine the data in the costs table.

You need to generate a report that displays the IDs of all products in the costs table whose unit price is at least 25% more than the unit cost. The details should be displayed in the descending order of 25% of the unit cost.

You issue the following query:

Which statement is true regarding the above query?

It executes and produces the required result.
It produces an error because an expression cannot be used in the order by clause.
It produces an error because the DESC option cannot be used with an expression in the order by clause.
It produces an error because the expression in the ORDER by clause should also be specified in the SELECT clause.

Correct answer: A

View the Exhibits and examine the structures of the products, sales, and customers tables.

You need to generate a report that gives details of the customer's last name, name of the product, and the quantity sold for a customers in 'Tokyo'.

Which two queries give the required result?

Option A
Option B
Option C
Option D

Correct answer: AC

View the Exhibit and examine the structure of the products table.

Evaluate the following query:

What would be the outcome of executing the above SQL statement?

It produces an error.
It shows the names of all products in the table.
It shows the names of products whose list price is the second highest in the table.
It shows the names of all products whose list price is less than the maximum list price.

Correct answer: C

You issued the following command:

SQL> DROP TABLE employees;

Which three statements are true?

All uncommitted transactions are committed.
All indexes and constraints defined on the table being dropped are also dropped.
Sequences used in the employees table become invalid.
The space used by the employees table is reclaimed immediately.
The employees table can be recovered using the rollback command.
The employees table is moved to the recycle bin.

Correct answer: ABF

Explanation:

A: If a user issues a DDL (CREATE, ALTER, or DROP) or DCL (GRANT or REVOKE) command, the transaction in progress (if any) will be committed.B: Dropping a table invalidates dependent objects, such as indexes and constraints.F: The DROP TABLE statement moves a table or object table to the recycle bin.Incorrect:Not B: In general sequences used in the table would not by affected when the table is dropped.Not D: Unless you specify the PURGE clause, the DROP TABLE statement does not result in space being released back to the tablespace for use by other objects, and the space continues to count toward the user's space quota.Not E: Dropping a table invalidates dependent objects and removes object privileges on the table. If you want to re-create the table, then you must regrant object privileges on the table, re-create the indexes, integrity constraints, and triggers for the table, and respecify its storage parameters.Reference: http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9003.htm

Examine the create table statements for the stores and sales tables.

SQL> CREATE TABLE stores(store_id NUMBER(4) CONSTRAINT store_id_pk PRIMARY KEY, store_name VARCHAR2(12), store_address VARCHAR2(20), start_date DATE);

SQL> CREATE TABLE sales(sales_id NUMBER(4) CONSTRAINT sales_id_pk PRIMARY KEY, item_id NUMBER(4), quantity NUMBER(10), sales_date DATE, store_id NUMBER(4), CONSTRAINT store_id_fk FOREIGN KEY(store_id) REFERENCES stores(store_id));

You executed the following statement:

SQL> DELETE from stores

WHERE store_id=900;

The statement fails due to the integrity constraint error:

ORA-02292: integrity constraint (HR.STORE_ID_FK) violated

Which three options ensure that the statement will execute successfully?

Disable the primary key in the STORES table.
Use CASCADE keyword with DELETE statement.
DELETE the rows with STORE_ID = 900 from the SALES table and then delete rows from STORES table.
Disable the FOREIGN KEY in SALES table and then delete the rows.
Create the foreign key in the SALES table on SALES_ID column with on DELETE CASCADE option.

Correct answer: ACD

You want to create a sales table with the following column specifications and data types:

SALESID: Number

STOREID: Number

ITEMID: Number

QTY: Number, should be set to 1 when no value is specified

SLSDATE: Date, should be set to current date when no value is specified

PAYMENT: Characters up to 30 characters, should be set to CASH when no value is specified

Which statement would create the table?

Option A
Option B
Option C
Option D

Correct answer: B

Explanation:

To specify the default value of payment field you must use DEFAULT 'CASH'. Reference: https://docs.oracle.com/database/121/SQLRF/statements_7002.htm#SQLRF01402

Examine the data in the CUST_NAME column of the customers table.

You need to display customers' second names where the second name starts with "Mc" or "MC."

Which query gives the required output?

Option A
Option B
Option C
Option D

Correct answer: B

Evaluate the following query:

SQL> SELECT TRUNC(ROUND(156.00, -1), -1)

FROM DUAL;

What would be the outcome?

Correct answer: C

Explanation:

Function Purpose ROUND(column|expression, n) Rounds the column, expression, or value to n decimal places or, if n is omitted, no decimal places (If n is negative, numbers to the left of decimal point are rounded.) TRUNC(column|expression, n) Truncates the column, expression, or value to n decimal places or, if n is omitted, n defaults to zero

You want to display 5 percent of the rows from the sales table for products with the lowest AMOUNT_SOLD and also want to include the rows that have the same AMOUNT_SOLD even if this causes the output to exceed 5 percent of the rows.

Which query will provide the required result?